Previous Topic

Next Topic

Query Definition

Defining a query in IQA is similar to writing an SQL statement. The difference is that the expressions you create to extract data from the database are based on business objects or existing queries, instead of tables.

IQA is designed to provide the maximum flexibility for defining queries. Because of that flexibility, you should check your resulting SQL expressions for validity: In Advanced mode, view the SQL statement for your query at the bottom of the Summary page.

To save a valid query, you must select at least one source and at least one column, and, if you select more than one source, the relationship between them. In most cases, a default relationship is inherited from your sources; you can override the default.

Users can access IQA from the iMIS Home page, a personal folder, or from the Generate reports page within a module. Administrators can access IQA from the iFC.

In This Section

Process overview

Tips for defining queries

Advanced mode options for sources

Creating or editing a query

Limiting the rows returned by a query

Configuring the global maximum number of rows returned by queries

See Also

Intelligent Query Architect (IQA)

Understanding Intelligent Query Architect

Adding a Filter

Specifying Output Columns

Specifying Sort Order

Query Examples

Integration with iMIS modules


ASI logo 10.6 Production Release. Updated 7/27/2006 3:53:14 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.